USE [NuevoConsultorioSQL]
GO

/****** Object:  Table [dbo].[DatosHorarioMedicoxDia]    Script Date: 03/10/2009 21:16:10 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[nDatosHorarioMedicoxDia](
	[codHorario] [uniqueidentifier] not null,
	[codHorarioAnterior] [int] NOT NULL,
	[codMedico] [uniqueidentifier] NULL,
	[Fecha] [datetime] NULL,
	[HoraInicio] [datetime] NULL,
	[HoraFin] [datetime] NULL,
	[Borrado] [bit] NOT NULL)

GO

ALTER TABLE [dbo].[DatosHorarioMedicoxDia] ADD  DEFAULT ((0)) FOR [Borrado]
GO


